package com.web22_2_1.mapper;

public class GradeSQL {
    public static final String SELECT_ALL_GRADE = "SELECT * FROM grades";
    public static final String ADD_GRADE = "insert into grades(StudentID,CourseID,Score,Term,ExamDate)\n" +
            "VALUES (?,?,?,?,?);";
    public static final String SELECT_GRADE_BY_ID = "SELECT * FROM grades WHERE GradeID=?";
    public static final String UPDATE_GRADE = "UPDATE grades SET StudentID = ?, CourseID = ?, Score = ?, Term = ?, ExamDate = ? WHERE GradeID = ?";
    public static final String DELETE_GRADE_BY_ID = "DELETE FROM grades WHERE GradeID=?";
}
